<?php

include("../config/db_config.php");
include("../vendor/php-pdo/class.db.php");
include("../vendor/simplehtmldom/simple_html_dom.php");
include("../vendor/amazon-ecs/lib/AmazonECS.class.php");

define('AWS_API_KEY', 'AKIAJOQTSNOGI6GIHAXQ');
define('AWS_API_SECRET_KEY', '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');
define('AWS_ASSOCIATE_TAG', 'bestchoiceever-20');

$amazonEcs = new AmazonECS(AWS_API_KEY, AWS_API_SECRET_KEY, 'COM', AWS_ASSOCIATE_TAG);
$amazonEcs->requestDelay(true);

$accord_db = new db("mysql:host=127.0.0.1;port=3306;dbname=accord", "root", "");

$us_states = array(
    "AL" => "Alabama",
    "AK" => "Alaska",
    "AZ" => "Arizona",
    "AR" => "Arkansas",
    "CA" => "California",
    "CO" => "Colorado",
    "CT" => "Connecticut",
    "DE" => "Delaware",
    "FL" => "Florida",
    "GA" => "Georgia",
    "HI" => "Hawaii",
    "ID" => "Idaho",
    "IL" => "Illinois",
    "IN" => "Indiana",
    "IA" => "Iowa",
    "KS" => "Kansas",
    "KY" => "Kentucky",
    "LA" => "Louisiana",
    "ME" => "Maine",
    "MD" => "Maryland",
    "MA" => "Massachusetts",
    "MI" => "Michigan",
    "MN" => "Minnesota",
    "MS" => "Mississippi",
    "MO" => "Missouri",
    "MT" => "Montana",
    "NE" => "Nebraska",
    "NV" => "Nevada",
    "NH" => "New Hampshire",
    "NJ" => "New Jersey",
    "NM" => "New Mexico",
    "NY" => "New York",
    "NC" => "North Carolina",
    "ND" => "North Dakota",
    "OH" => "Ohio",
    "OK" => "Oklahoma",
    "OR" => "Oregon",
    "PA" => "Pennsylvania",
    "RI" => "Rhode Island",
    "SC" => "South Carolina",
    "SD" => "South Dakota",
    "TN" => "Tennessee",
    "TX" => "Texas",
    "UT" => "Utah",
    "VT" => "Vermont",
    "VA" => "Virginia",
    "WA" => "Washington",
    "WV" => "West Virginia",
    "WI" => "Wisconsin",
    "WY" => "Wyoming"
);

$ddate = date("Y-m-d");
$date = new DateTime($ddate);
$week = $date->format("W");
$update_id = date("Y") . "-" . $week;

$results = $accord_db->select("products", "`update_id` <> '{$update_id}' AND `valid` <> 2 LIMIT 1");

if (!$results) {
    exit();
}

$product = $results[0];


$response = $amazonEcs->responseGroup('ItemAttributes,OfferFull,SalesRank,Images')->lookup($product['asin']);
if ($response->OperationRequest) unset($response->OperationRequest);
if ($response->Items->Request) unset($response->Items->Request);
if ($response->Items->Item->DetailPageURL) unset($response->Items->Item->DetailPageURL);
if ($response->Items->Item->ItemLinks) unset($response->Items->Item->ItemLinks);
if ($response->Items->Item->ImageSets) unset($response->Items->Item->ImageSets);
if ($response->Items->Item->SmallImage->Height) unset($response->Items->Item->SmallImage->Height);
if ($response->Items->Item->SmallImage->Width) unset($response->Items->Item->SmallImage->Width);
if ($response->Items->Item->MediumImage->Height) unset($response->Items->Item->MediumImage->Height);
if ($response->Items->Item->MediumImage->Width) unset($response->Items->Item->MediumImage->Width);
if ($response->Items->Item->LargeImage->Height) unset($response->Items->Item->LargeImage->Height);
if ($response->Items->Item->LargeImage->Width) unset($response->Items->Item->LargeImage->Width);

if (
    !$response->Items->Item
    || !$response->Items->Item->ItemAttributes->Manufacturer
    || !$response->Items->Item->ItemAttributes->Model
    || !$response->Items->Item->Offers->Offer->OfferListing->Price->FormattedPrice
) {
    $accord_db->delete("product_cat_model_lkp", "product_asin = '{$product['asin']}'");
    $accord_db->update("products", array("valid" => 2), "asin = '{$product['asin']}'");
    exit();
}
$product_title = $response->Items->Item->ItemAttributes->Manufacturer . " " . $response->Items->Item->ItemAttributes->Model;
$accord_db->delete("product_serialize", "product_asin = '{$product['asin']}'");
$accord_db->delete("product_offers", "product_asin = '{$product['asin']}'");
$item_detail = $response->Items->Item;
$product_serialize_insert = array(
    "product_asin" => $product['asin'],
    "serialize" => serialize($item_detail)
);
$accord_db->insert("product_serialize", $product_serialize_insert);
$product_price_db = $accord_db->select("product_price", "`product_asin` = '{$product['asin']}'");
$price_amount = $item_detail->Offers->Offer->OfferListing->Price->Amount ? $item_detail->Offers->Offer->OfferListing->Price->Amount : 0;
$price_formatted = $item_detail->Offers->Offer->OfferListing->Price->FormattedPrice ? $item_detail->Offers->Offer->OfferListing->Price->FormattedPrice : 0;
if (!$product_price_db) {
    $product_price_insert = array(
        "product_asin" => $product['asin'],
        "lowest_price" => $price_amount,
        "lowest_price_formatted" => $price_formatted,
        "lowest_price_when" => time(),
        "current_price" => $price_amount,
        "current_price_formatted" => $price_formatted,
        "current_price_when" => time(),
        "highest_price" => $price_amount,
        "highest_price_formatted" => $price_formatted,
        "highest_price_when" => time(),
    );
    $accord_db->insert("product_price", $product_price_insert);
} else {
    $accord_db->update(
        "product_price",
        array("current_price" => $price_amount, "current_price_formatted" => $price_formatted, "current_price_when" => time()),
        "product_asin = '{$product['asin']}'"
    );
    if ($price_amount < $product_price_db[0]['lowest_price']) {
        $accord_db->update(
            "product_price",
            array("lowest_price" => $price_amount, "lowest_price_formatted" => $price_formatted, "lowest_price_when" => time()),
            "product_asin = '{$product['asin']}'"
        );
    }
    if ($price_amount > $product_price_db[0]['highest_price']) {
        $accord_db->update(
            "product_price",
            array("highest_price" => $price_amount, "highest_price_formatted" => $price_formatted, "highest_price_when" => time()),
            "product_asin = '{$product['asin']}'"
        );
    }
}


$next_offer_page = true;
$start_index = 0;
while ($next_offer_page) {
    $html = file_get_html('http://www.amazon.com/gp/offer-listing/' . $product['asin'] . '?startIndex=' . $start_index);
    if (!count($html->find('div.olpOffer'))) {
        $next_offer_page = false;
    } else {
        foreach ($html->find('div.olpOffer') as $element) {
            $product_offers_insert = array();
            $offer_html = str_get_html($element->outertext);
            $offer_price_formatted = $offer_html->find("div.a-column span.a-color-price", 0);
            $offer_price_formatted = trim($offer_price_formatted->plaintext);
            $offer_price = str_replace(".", "", $offer_price_formatted);
            $offer_price = str_replace("$", "", $offer_price);

            $shipping_info = $offer_html->find("div.a-column p.olpShippingInfo", 0);
            $shipping_info = str_replace(" ", "", $shipping_info->plaintext);
            $shipping_info = str_replace("FREEShippingonordersover$35.00.Details", "", $shipping_info);
            $shipping_info = str_replace("&", "", $shipping_info);
            $shipping_info = str_replace("+", "", $shipping_info);
            $shipping_info = str_replace(".Details", "", $shipping_info);
            $shipping_info = str_replace("AmazonPrimeTM", "", $shipping_info);
            $shipping_info = str_replace("shipping", "", $shipping_info);
            $shipping_info = str_replace("FREEShipping", "", $shipping_info);
            $shipping_info = trim($shipping_info);
            $shipping_info = $shipping_info != "" ? $shipping_info : 0;

            $condition = $offer_html->find("div.a-column h3.olpCondition", 0);
            $condition = str_replace(" ", "", $condition->plaintext);

            $product_offers_insert['seller_name'] = "";
            $seller_name = $offer_html->find("div.a-column p.olpSellerName span a", 0);
            if ($seller_name != null) {
                $product_offers_insert['seller_name'] = $seller_name->plaintext;
            }

            $product_offers_insert['seller_img'] = "";
            $seller_img = $offer_html->find("div.a-column p.olpSellerName a img", 0);
            if ($seller_img != null) {
                $product_offers_insert['seller_img'] = $seller_img->src;
            }
            $product_offers_insert['seller_id'] = "";
            if ($seller_img != null && $seller_name == null) {
                $seller_id = $offer_html->find("div.a-column p.olpSellerName a", 0);
                $matches = array();
                preg_match('/shops\/([A-Z0-9]+)\/ref=/', $seller_id->href, $matches);
                $product_offers_insert['seller_id'] = $matches[1];
            } elseif ($seller_img == null && $seller_name != null) {
                $matches = array();
                preg_match('/seller\=([A-Z0-9]+)/', $seller_name->href, $matches);
                $product_offers_insert['seller_id'] = $matches[1];
            }

            $ship_from = $offer_html->find("div.olpDeliveryColumn", 0);
            $ship_from = trim($ship_from->plaintext);
            $ship_from_state = "";
            foreach ($us_states as $code => $states) {
                if (strpos($ship_from, "Ships from {$code}, United States") === 0) {
                    $ship_from_state = $states;
                }
            }

            if ($product_offers_insert['seller_img'] != "" || $product_offers_insert['seller_name'] != "") {
                $sql = <<<MYSQL
INSERT INTO `accord`.`product_offers` (`product_asin`, `condition`, `seller_name`,`seller_id`, `seller_img`, `price`, `price_formatted`, `shipping`, `ship_from`)
VALUES ("{$product['asin']}", "{$condition}", "{$product_offers_insert['seller_name']}","{$product_offers_insert['seller_id']}", "{$product_offers_insert['seller_img']}", {$offer_price}, "{$offer_price_formatted}", "{$shipping_info}", "{$ship_from_state}");
MYSQL;
                $accord_db->run($sql);
            }
        }
        $start_index += 10;
    }
}

$reviewers_html = $html->find("div.a-spacing-small span.offerListingPage{$product['asin']}", 0);
$reviews_count = ($reviewers_html) ? $reviewers_html->plaintext : 0;
$reviews_count = str_replace(" ", "", $reviews_count);
$reviews_count = str_replace("customerreviews", "", $reviews_count);
$reviews_count = str_replace("customerreview", "", $reviews_count);
$saved = $item_detail->Offers->Offer->OfferListing->PercentageSaved ? $item_detail->Offers->Offer->OfferListing->PercentageSaved : 0;
$accord_db->update(
    "products",
    array(
        "title" => $product_title,
        "url" => url_slug($product_title) . "-" . $product['asin'] . ".html",
        "update_id" => $update_id,
        "reviewers" => $reviews_count,
        "updated_time" => time(),
        "saved" => $saved,
        "valid" => 1
    ),
    "asin = '{$product['asin']}'"
);
function url_slug($str, $options = array())
{
    // Make sure string is in UTF-8 and strip invalid UTF-8 characters
    $str = mb_convert_encoding((string)$str, 'UTF-8', mb_list_encodings());

    $defaults = array(
        'delimiter' => '-',
        'limit' => null,
        'lowercase' => true,
        'replacements' => array(),
        'transliterate' => false,
    );

    // Merge options
    $options = array_merge($defaults, $options);

    $char_map = array(
        // Latin
        'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Æ' => 'AE', 'Ç' => 'C',
        'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I',
        'Ð' => 'D', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ő' => 'O',
        'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ű' => 'U', 'Ý' => 'Y', 'Þ' => 'TH',
        'ß' => 'ss',
        'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'ae', 'ç' => 'c',
        'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i',
        'ð' => 'd', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ő' => 'o',
        'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ü' => 'u', 'ű' => 'u', 'ý' => 'y', 'þ' => 'th',
        'ÿ' => 'y',

        // Latin symbols
        '©' => '(c)',

        // Greek
        'Α' => 'A', 'Β' => 'B', 'Γ' => 'G', 'Δ' => 'D', 'Ε' => 'E', 'Ζ' => 'Z', 'Η' => 'H', 'Θ' => '8',
        'Ι' => 'I', 'Κ' => 'K', 'Λ' => 'L', 'Μ' => 'M', 'Ν' => 'N', 'Ξ' => '3', 'Ο' => 'O', 'Π' => 'P',
        'Ρ' => 'R', 'Σ' => 'S', 'Τ' => 'T', 'Υ' => 'Y', 'Φ' => 'F', 'Χ' => 'X', 'Ψ' => 'PS', 'Ω' => 'W',
        'Ά' => 'A', 'Έ' => 'E', 'Ί' => 'I', 'Ό' => 'O', 'Ύ' => 'Y', 'Ή' => 'H', 'Ώ' => 'W', 'Ϊ' => 'I',
        'Ϋ' => 'Y',
        'α' => 'a', 'β' => 'b', 'γ' => 'g', 'δ' => 'd', 'ε' => 'e', 'ζ' => 'z', 'η' => 'h', 'θ' => '8',
        'ι' => 'i', 'κ' => 'k', 'λ' => 'l', 'μ' => 'm', 'ν' => 'n', 'ξ' => '3', 'ο' => 'o', 'π' => 'p',
        'ρ' => 'r', 'σ' => 's', 'τ' => 't', 'υ' => 'y', 'φ' => 'f', 'χ' => 'x', 'ψ' => 'ps', 'ω' => 'w',
        'ά' => 'a', 'έ' => 'e', 'ί' => 'i', 'ό' => 'o', 'ύ' => 'y', 'ή' => 'h', 'ώ' => 'w', 'ς' => 's',
        'ϊ' => 'i', 'ΰ' => 'y', 'ϋ' => 'y', 'ΐ' => 'i',

        // Turkish
        'Ş' => 'S', 'İ' => 'I', 'Ç' => 'C', 'Ü' => 'U', 'Ö' => 'O', 'Ğ' => 'G',
        'ş' => 's', 'ı' => 'i', 'ç' => 'c', 'ü' => 'u', 'ö' => 'o', 'ğ' => 'g',

        // Russian
        'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ё' => 'Yo', 'Ж' => 'Zh',
        'З' => 'Z', 'И' => 'I', 'Й' => 'J', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O',
        'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'H', 'Ц' => 'C',
        'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Sh', 'Ъ' => '', 'Ы' => 'Y', 'Ь' => '', 'Э' => 'E', 'Ю' => 'Yu',
        'Я' => 'Ya',
        'а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ё' => 'yo', 'ж' => 'zh',
        'з' => 'z', 'и' => 'i', 'й' => 'j', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o',
        'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'c',
        'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sh', 'ъ' => '', 'ы' => 'y', 'ь' => '', 'э' => 'e', 'ю' => 'yu',
        'я' => 'ya',

        // Ukrainian
        'Є' => 'Ye', 'І' => 'I', 'Ї' => 'Yi', 'Ґ' => 'G',
        'є' => 'ye', 'і' => 'i', 'ї' => 'yi', 'ґ' => 'g',

        // Czech
        'Č' => 'C', 'Ď' => 'D', 'Ě' => 'E', 'Ň' => 'N', 'Ř' => 'R', 'Š' => 'S', 'Ť' => 'T', 'Ů' => 'U',
        'Ž' => 'Z',
        'č' => 'c', 'ď' => 'd', 'ě' => 'e', 'ň' => 'n', 'ř' => 'r', 'š' => 's', 'ť' => 't', 'ů' => 'u',
        'ž' => 'z',

        // Polish
        'Ą' => 'A', 'Ć' => 'C', 'Ę' => 'e', 'Ł' => 'L', 'Ń' => 'N', 'Ó' => 'o', 'Ś' => 'S', 'Ź' => 'Z',
        'Ż' => 'Z',
        'ą' => 'a', 'ć' => 'c', 'ę' => 'e', 'ł' => 'l', 'ń' => 'n', 'ó' => 'o', 'ś' => 's', 'ź' => 'z',
        'ż' => 'z',

        // Latvian
        'Ā' => 'A', 'Č' => 'C', 'Ē' => 'E', 'Ģ' => 'G', 'Ī' => 'i', 'Ķ' => 'k', 'Ļ' => 'L', 'Ņ' => 'N',
        'Š' => 'S', 'Ū' => 'u', 'Ž' => 'Z',
        'ā' => 'a', 'č' => 'c', 'ē' => 'e', 'ģ' => 'g', 'ī' => 'i', 'ķ' => 'k', 'ļ' => 'l', 'ņ' => 'n',
        'š' => 's', 'ū' => 'u', 'ž' => 'z'
    );

    // Make custom replacements
    $str = preg_replace(array_keys($options['replacements']), $options['replacements'], $str);

    // Transliterate characters to ASCII
    if ($options['transliterate']) {
        $str = str_replace(array_keys($char_map), $char_map, $str);
    }

    // Replace non-alphanumeric characters with our delimiter
    $str = preg_replace('/[^\p{L}\p{Nd}]+/u', $options['delimiter'], $str);

    // Remove duplicate delimiters
    $str = preg_replace('/(' . preg_quote($options['delimiter'], '/') . '){2,}/', '$1', $str);

    // Truncate slug to max. characters
    $str = mb_substr($str, 0, ($options['limit'] ? $options['limit'] : mb_strlen($str, 'UTF-8')), 'UTF-8');

    // Remove delimiter from ends
    $str = trim($str, $options['delimiter']);

    return $options['lowercase'] ? mb_strtolower($str, 'UTF-8') : $str;
}